CREATE EXTERNAL TABLE IF NOT EXISTS jms_ods.lq_problem_bill(
id                                                 bigint                         COMMENT 'ID',
version                                            bigint                         COMMENT 'VERSION',
createTime                                         String                         COMMENT 'CREATETIME',
lastUpdateTime                                     String                         COMMENT 'LASTUPDATETIME',
billCode                                           String                         COMMENT 'BILLCODE',
expressCompanyCode                                 String                         COMMENT 'EXPRESSCOMPANYCODE',
serviceSiteCode                                    String                         COMMENT 'SERVICESITECODE',
problemType                                        String                         COMMENT 'PROBLEMTYPE',
problemDesc                                        String                         COMMENT 'PROBLEMDESC',
appUserId                                          String                         COMMENT 'APPUSERID',
operationTime                                      String                         COMMENT '操作时间'
)
COMMENT ''
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/lq_problem_bill'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
);